﻿using System;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using Moon.Orm;

namespace czc
{

    [Table("[AuthorizeCodes]", DbType.SqlServer)]
    public class AuthorizeCodesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase AuthorizeCodeId = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.OnlyPrimaryKey, "[AuthorizeCodeId]");
        public static readonly FieldBase AuthorizeName = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[AuthorizeName]");
        public static readonly FieldBase ParentAuthorizeCodeId = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[ParentAuthorizeCodeId]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[AuthorizeCodes]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[CodeCategories]", DbType.SqlServer)]
    public class CodeCategoriesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase CategoryId = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.OnlyPrimaryKey, "[CategoryId]");
        public static readonly FieldBase CategoryOrder = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[CategoryOrder]");
        public static readonly FieldBase CategoryName = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[CategoryName]");
        public static readonly FieldBase CategoryDescription = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[CategoryDescription]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[CodeCategories]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[CodeInfo]", DbType.SqlServer)]
    public class CodeInfoSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase CodeId = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.OnlyPrimaryKey, "[CodeId]");
        public static readonly FieldBase ParentCodeId = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[ParentCodeId]");
        public static readonly FieldBase CategoryId = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.ForeignKey, "[CategoryId]");
        public static readonly FieldBase CodeOrder = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[CodeOrder]");
        public static readonly FieldBase EnglishValue = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[EnglishValue]");
        public static readonly FieldBase ChineseValue = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[ChineseValue]");
        public static readonly FieldBase IsEnable = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[IsEnable]");
        public static readonly FieldBase CodeDescription = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[CodeDescription]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[CodeInfo]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[ControlButtons]", DbType.SqlServer)]
    public class ControlButtonsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase ControlId = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.OnlyPrimaryKey, "[ControlId]");
        public static readonly FieldBase ControlName = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[ControlName]");
        public static readonly FieldBase ControlOrder = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[ControlOrder]");
        public static readonly FieldBase ControlIcon = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[ControlIcon]");
        public static readonly FieldBase Remark = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[Remark]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[ControlButtons]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[FunctionInRoles]", DbType.SqlServer)]
    public class FunctionInRolesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase RoleFunctionId = new FieldBase(DbType.SqlServer, "[FunctionInRoles]", FieldType.OnlyPrimaryKey, "[RoleFunctionId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[FunctionInRoles]", FieldType.ForeignKey, "[RoleId]");
        public static readonly FieldBase FunctionId = new FieldBase(DbType.SqlServer, "[FunctionInRoles]", FieldType.ForeignKey, "[FunctionId]");
    }

    [Table("[FunctionsInfo]", DbType.SqlServer)]
    public class FunctionsInfoSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase FunctionId = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.OnlyPrimaryKey, "[FunctionId]");
        public static readonly FieldBase ParentFunctionId = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[ParentFunctionId]");
        public static readonly FieldBase FunctionOrder = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[FunctionOrder]");
        public static readonly FieldBase FunctionDescription = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[FunctionDescription]");
        public static readonly FieldBase FunctionName = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[FunctionName]");
        public static readonly FieldBase URL = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[URL]");
        public static readonly FieldBase IsShow = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[IsShow]");
        public static readonly FieldBase IsEnable = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[IsEnable]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[FunctionsInfo]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[GroupInRoles]", DbType.SqlServer)]
    public class GroupInRolesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase GroupRoleId = new FieldBase(DbType.SqlServer, "[GroupInRoles]", FieldType.OnlyPrimaryKey, "[GroupRoleId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[GroupInRoles]", FieldType.ForeignKey, "[RoleId]");
        public static readonly FieldBase GroupId = new FieldBase(DbType.SqlServer, "[GroupInRoles]", FieldType.ForeignKey, "[GroupId]");
    }

    [Table("[Groups]", DbType.SqlServer)]
    public class GroupsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase GroupId = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.OnlyPrimaryKey, "[GroupId]");
        public static readonly FieldBase ParentGroupId = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[ParentGroupId]");
        public static readonly FieldBase GroupOrder = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[GroupOrder]");
        public static readonly FieldBase GroupName = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[GroupName]");
        public static readonly FieldBase GroupDescription = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[GroupDescription]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[Groups]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[LoginHistory]", DbType.SqlServer)]
    public class LoginHistorySet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase LHistoryId = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.OnlyPrimaryKey, "[LHistoryId]");
        public static readonly FieldBase UserId = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[UserId]");
        public static readonly FieldBase UserName = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[UserName]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[RoleId]");
        public static readonly FieldBase RoleName = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[RoleName]");
        public static readonly FieldBase ClientPC = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[ClientPC]");
        public static readonly FieldBase ClientIP = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[ClientIP]");
        public static readonly FieldBase LoginTime = new FieldBase(DbType.SqlServer, "[LoginHistory]", FieldType.Common, "[LoginTime]");
    }

    [Table("[MenuButtons]", DbType.SqlServer)]
    public class MenuButtonsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase MenuButtonId = new FieldBase(DbType.SqlServer, "[MenuButtons]", FieldType.OnlyPrimaryKey, "[MenuButtonId]");
        public static readonly FieldBase FunctionId = new FieldBase(DbType.SqlServer, "[MenuButtons]", FieldType.ForeignKey, "[FunctionId]");
        public static readonly FieldBase ControlId = new FieldBase(DbType.SqlServer, "[MenuButtons]", FieldType.ForeignKey, "[ControlId]");
    }

    [Table("[RoleAuthorizes]", DbType.SqlServer)]
    public class RoleAuthorizesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase RoleAuthorizeId = new FieldBase(DbType.SqlServer, "[RoleAuthorizes]", FieldType.OnlyPrimaryKey, "[RoleAuthorizeId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[RoleAuthorizes]", FieldType.ForeignKey, "[RoleId]");
        public static readonly FieldBase AuthorizeCodeId = new FieldBase(DbType.SqlServer, "[RoleAuthorizes]", FieldType.ForeignKey, "[AuthorizeCodeId]");
    }

    [Table("[RoleColumns]", DbType.SqlServer)]
    public class RoleColumnsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase ColumnRoleId = new FieldBase(DbType.SqlServer, "[RoleColumns]", FieldType.OnlyPrimaryKey, "[ColumnRoleId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[RoleColumns]", FieldType.ForeignKey, "[RoleId]");
        public static readonly FieldBase FunctionId = new FieldBase(DbType.SqlServer, "[RoleColumns]", FieldType.ForeignKey, "[FunctionId]");
        public static readonly FieldBase RoleType = new FieldBase(DbType.SqlServer, "[RoleColumns]", FieldType.Common, "[RoleType]");
        public static readonly FieldBase FieldName = new FieldBase(DbType.SqlServer, "[RoleColumns]", FieldType.Common, "[FieldName]");
    }

    [Table("[RoleMenuButtons]", DbType.SqlServer)]
    public class RoleMenuButtonsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase RoleMenuButtonId = new FieldBase(DbType.SqlServer, "[RoleMenuButtons]", FieldType.OnlyPrimaryKey, "[RoleMenuButtonId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[RoleMenuButtons]", FieldType.ForeignKey, "[RoleId]");
        public static readonly FieldBase FunctionId = new FieldBase(DbType.SqlServer, "[RoleMenuButtons]", FieldType.ForeignKey, "[FunctionId]");
        public static readonly FieldBase ControlId = new FieldBase(DbType.SqlServer, "[RoleMenuButtons]", FieldType.ForeignKey, "[ControlId]");
    }

    [Table("[Roles]", DbType.SqlServer)]
    public class RolesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.OnlyPrimaryKey, "[RoleId]");
        public static readonly FieldBase RoleOrder = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[RoleOrder]");
        public static readonly FieldBase RoleName = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[RoleName]");
        public static readonly FieldBase RoleDescription = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[RoleDescription]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[Roles]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[SystemLogs]", DbType.SqlServer)]
    public class SystemLogsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase LogId = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.OnlyPrimaryKey, "[LogId]");
        public static readonly FieldBase LogSources = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[LogSources]");
        public static readonly FieldBase LogCategoryId = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[LogCategoryId]");
        public static readonly FieldBase LogCategoryName = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[LogCategoryName]");
        public static readonly FieldBase LogContents = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[LogContents]");
        public static readonly FieldBase LogRemark = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[LogRemark]");
        public static readonly FieldBase RecordTime = new FieldBase(DbType.SqlServer, "[SystemLogs]", FieldType.Common, "[RecordTime]");
    }

    [Table("[SystemParameters]", DbType.SqlServer)]
    public class SystemParametersSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase SysParametersId = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.OnlyPrimaryKey, "[SysParametersId]");
        public static readonly FieldBase ParameterValue = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[ParameterValue]");
        public static readonly FieldBase IsEdit = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[IsEdit]");
        public static readonly FieldBase ParameterDescription = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[ParameterDescription]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase ModifyOn = new FieldBase(DbType.SqlServer, "[SystemParameters]", FieldType.Common, "[ModifyOn]");
    }

    [Table("[UserInGroups]", DbType.SqlServer)]
    public class UserInGroupsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase GroupUserId = new FieldBase(DbType.SqlServer, "[UserInGroups]", FieldType.OnlyPrimaryKey, "[GroupUserId]");
        public static readonly FieldBase GroupId = new FieldBase(DbType.SqlServer, "[UserInGroups]", FieldType.ForeignKey, "[GroupId]");
        public static readonly FieldBase UserId = new FieldBase(DbType.SqlServer, "[UserInGroups]", FieldType.ForeignKey, "[UserId]");
    }

    [Table("[UserInRoles]", DbType.SqlServer)]
    public class UserInRolesSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase UserRoleId = new FieldBase(DbType.SqlServer, "[UserInRoles]", FieldType.OnlyPrimaryKey, "[UserRoleId]");
        public static readonly FieldBase UserId = new FieldBase(DbType.SqlServer, "[UserInRoles]", FieldType.ForeignKey, "[UserId]");
        public static readonly FieldBase RoleId = new FieldBase(DbType.SqlServer, "[UserInRoles]", FieldType.ForeignKey, "[RoleId]");
    }

    [Table("[UserofSettings]", DbType.SqlServer)]
    public class UserofSettingsSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase UserSettingId = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.OnlyPrimaryKey, "[UserSettingId]");
        public static readonly FieldBase UserId = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.ForeignKey, "[UserId]");
        public static readonly FieldBase SettingCodeNo = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.Common, "[SettingCodeNo]");
        public static readonly FieldBase SettingName = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.Common, "[SettingName]");
        public static readonly FieldBase SettingValue = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.Common, "[SettingValue]");
        public static readonly FieldBase SettingDescription = new FieldBase(DbType.SqlServer, "[UserofSettings]", FieldType.Common, "[SettingDescription]");
    }

    [Table("[Users]", DbType.SqlServer)]
    public class UsersSet : MQLBase
    {
        public static new MQLBase Select(params FieldBase[] fields)
        {
            return MQLBase.Select(fields);
        }
        public static new MQLBase SelectAll()
        {
            return MQLBase.SelectAll();
        }
        public static readonly FieldBase UserId = new FieldBase(DbType.SqlServer, "[Users]", FieldType.OnlyPrimaryKey, "[UserId]");
        public static readonly FieldBase UserName = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[UserName]");
        public static readonly FieldBase PassWord = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[PassWord]");
        public static readonly FieldBase UserRoleId = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[UserRoleId]");
        public static readonly FieldBase GroupId = new FieldBase(DbType.SqlServer, "[Users]", FieldType.ForeignKey, "[GroupId]");
        public static readonly FieldBase UserSettingId = new FieldBase(DbType.SqlServer, "[Users]", FieldType.ForeignKey, "[UserSettingId]");
        public static readonly FieldBase IsEnable = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[IsEnable]");
        public static readonly FieldBase LoginsNumber = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[LoginsNumber]");
        public static readonly FieldBase CreateBy = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[CreateBy]");
        public static readonly FieldBase CreateOn = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[CreateOn]");
        public static readonly FieldBase ModifyBy = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[ModifyBy]");
        public static readonly FieldBase 更新时间 = new FieldBase(DbType.SqlServer, "[Users]", FieldType.Common, "[更新时间]");
    }


    [Table("[AuthorizeCodes]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "AuthorizeCodeId")]
    public class AuthorizeCodes : EntityBase
    {

        /// <summary>
        /// 授权代码ID
        /// </summary>
        public String AuthorizeCodeId
        {
            get { return GetPropertyValue<String>("AuthorizeCodeId"); }
            set { SetPropertyValue("AuthorizeCodeId", value); }
        }

        /// <summary>
        /// 授权名称
        /// </summary>
        public String AuthorizeName
        {
            get { return GetPropertyValue<String>("AuthorizeName"); }
            set { SetPropertyValue("AuthorizeName", value); }
        }

        /// <summary>
        /// 上级代码ID
        /// </summary>
        public String ParentAuthorizeCodeId
        {
            get { return GetPropertyValue<String>("ParentAuthorizeCodeId"); }
            set { SetPropertyValue("ParentAuthorizeCodeId", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[CodeCategories]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "CategoryId")]
    public class CodeCategories : EntityBase
    {

        /// <summary>
        /// 编码类型ID
        /// </summary>
        public String CategoryId
        {
            get { return GetPropertyValue<String>("CategoryId"); }
            set { SetPropertyValue("CategoryId", value); }
        }

        /// <summary>
        /// 分类排序
        /// </summary>
        public Int32? CategoryOrder
        {
            get { return GetPropertyValue<Int32?>("CategoryOrder"); }
            set { SetPropertyValue("CategoryOrder", value); }
        }

        /// <summary>
        /// 分类名称
        /// </summary>
        public String CategoryName
        {
            get { return GetPropertyValue<String>("CategoryName"); }
            set { SetPropertyValue("CategoryName", value); }
        }

        /// <summary>
        /// 分类描述
        /// </summary>
        public String CategoryDescription
        {
            get { return GetPropertyValue<String>("CategoryDescription"); }
            set { SetPropertyValue("CategoryDescription", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[CodeInfo]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "CodeId")]
    public class CodeInfo : EntityBase
    {

        /// <summary>
        /// 编码ID
        /// </summary>
        public String CodeId
        {
            get { return GetPropertyValue<String>("CodeId"); }
            set { SetPropertyValue("CodeId", value); }
        }

        /// <summary>
        /// 编码分类父ID
        /// </summary>
        public String ParentCodeId
        {
            get { return GetPropertyValue<String>("ParentCodeId"); }
            set { SetPropertyValue("ParentCodeId", value); }
        }

        /// <summary>
        /// 编码类型ID
        /// </summary>
        public String CategoryId
        {
            get { return GetPropertyValue<String>("CategoryId"); }
            set { SetPropertyValue("CategoryId", value); }
        }

        /// <summary>
        /// 编码排序
        /// </summary>
        public Int32? CodeOrder
        {
            get { return GetPropertyValue<Int32?>("CodeOrder"); }
            set { SetPropertyValue("CodeOrder", value); }
        }

        /// <summary>
        /// 英文值
        /// </summary>
        public String EnglishValue
        {
            get { return GetPropertyValue<String>("EnglishValue"); }
            set { SetPropertyValue("EnglishValue", value); }
        }

        /// <summary>
        /// 中文值
        /// </summary>
        public String ChineseValue
        {
            get { return GetPropertyValue<String>("ChineseValue"); }
            set { SetPropertyValue("ChineseValue", value); }
        }

        /// <summary>
        /// 是否启用（默认True）
        /// </summary>
        public Boolean? IsEnable
        {
            get { return GetPropertyValue<Boolean?>("IsEnable"); }
            set { SetPropertyValue("IsEnable", value); }
        }

        /// <summary>
        /// 编码描述
        /// </summary>
        public String CodeDescription
        {
            get { return GetPropertyValue<String>("CodeDescription"); }
            set { SetPropertyValue("CodeDescription", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[ControlButtons]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "ControlId")]
    public class ControlButtons : EntityBase
    {

        /// <summary>
        /// 按钮ID
        /// </summary>
        public String ControlId
        {
            get { return GetPropertyValue<String>("ControlId"); }
            set { SetPropertyValue("ControlId", value); }
        }

        /// <summary>
        /// 按钮名称
        /// </summary>
        public String ControlName
        {
            get { return GetPropertyValue<String>("ControlName"); }
            set { SetPropertyValue("ControlName", value); }
        }

        /// <summary>
        /// 按钮排序
        /// </summary>
        public Int32? ControlOrder
        {
            get { return GetPropertyValue<Int32?>("ControlOrder"); }
            set { SetPropertyValue("ControlOrder", value); }
        }

        /// <summary>
        /// 按钮图标
        /// </summary>
        public Object ControlIcon
        {
            get { return GetPropertyValue<Object>("ControlIcon"); }
            set { SetPropertyValue("ControlIcon", value); }
        }

        /// <summary>
        /// 
        /// </summary>
        public String Remark
        {
            get { return GetPropertyValue<String>("Remark"); }
            set { SetPropertyValue("Remark", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[FunctionInRoles]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "RoleFunctionId")]
    public class FunctionInRoles : EntityBase
    {

        /// <summary>
        /// 角色功能ID
        /// </summary>
        public String RoleFunctionId
        {
            get { return GetPropertyValue<String>("RoleFunctionId"); }
            set { SetPropertyValue("RoleFunctionId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 功能ID
        /// </summary>
        public String FunctionId
        {
            get { return GetPropertyValue<String>("FunctionId"); }
            set { SetPropertyValue("FunctionId", value); }
        }
    }

    [Table("[FunctionsInfo]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "FunctionId")]
    public class FunctionsInfo : EntityBase
    {

        /// <summary>
        /// 功能ID
        /// </summary>
        public String FunctionId
        {
            get { return GetPropertyValue<String>("FunctionId"); }
            set { SetPropertyValue("FunctionId", value); }
        }

        /// <summary>
        /// 功能上级ID
        /// </summary>
        public String ParentFunctionId
        {
            get { return GetPropertyValue<String>("ParentFunctionId"); }
            set { SetPropertyValue("ParentFunctionId", value); }
        }

        /// <summary>
        /// 顺序
        /// </summary>
        public Int32? FunctionOrder
        {
            get { return GetPropertyValue<Int32?>("FunctionOrder"); }
            set { SetPropertyValue("FunctionOrder", value); }
        }

        /// <summary>
        /// 描述
        /// </summary>
        public String FunctionDescription
        {
            get { return GetPropertyValue<String>("FunctionDescription"); }
            set { SetPropertyValue("FunctionDescription", value); }
        }

        /// <summary>
        /// 名称
        /// </summary>
        public String FunctionName
        {
            get { return GetPropertyValue<String>("FunctionName"); }
            set { SetPropertyValue("FunctionName", value); }
        }

        /// <summary>
        /// URL
        /// </summary>
        public String URL
        {
            get { return GetPropertyValue<String>("URL"); }
            set { SetPropertyValue("URL", value); }
        }

        /// <summary>
        /// 是否可见（默认True）
        /// </summary>
        public Boolean? IsShow
        {
            get { return GetPropertyValue<Boolean?>("IsShow"); }
            set { SetPropertyValue("IsShow", value); }
        }

        /// <summary>
        /// 是否启用
        /// </summary>
        public Boolean? IsEnable
        {
            get { return GetPropertyValue<Boolean?>("IsEnable"); }
            set { SetPropertyValue("IsEnable", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[GroupInRoles]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "GroupRoleId")]
    public class GroupInRoles : EntityBase
    {

        /// <summary>
        /// 机构角色ID
        /// </summary>
        public String GroupRoleId
        {
            get { return GetPropertyValue<String>("GroupRoleId"); }
            set { SetPropertyValue("GroupRoleId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 机构ID
        /// </summary>
        public String GroupId
        {
            get { return GetPropertyValue<String>("GroupId"); }
            set { SetPropertyValue("GroupId", value); }
        }
    }

    [Table("[Groups]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "GroupId")]
    public class Groups : EntityBase
    {

        /// <summary>
        /// 机构编号
        /// </summary>
        public String GroupId
        {
            get { return GetPropertyValue<String>("GroupId"); }
            set { SetPropertyValue("GroupId", value); }
        }

        /// <summary>
        /// 上级编号
        /// </summary>
        public String ParentGroupId
        {
            get { return GetPropertyValue<String>("ParentGroupId"); }
            set { SetPropertyValue("ParentGroupId", value); }
        }

        /// <summary>
        /// 机构顺序（值小靠前）
        /// </summary>
        public Int32? GroupOrder
        {
            get { return GetPropertyValue<Int32?>("GroupOrder"); }
            set { SetPropertyValue("GroupOrder", value); }
        }

        /// <summary>
        /// 机构名称
        /// </summary>
        public String GroupName
        {
            get { return GetPropertyValue<String>("GroupName"); }
            set { SetPropertyValue("GroupName", value); }
        }

        /// <summary>
        /// 机构描述
        /// </summary>
        public String GroupDescription
        {
            get { return GetPropertyValue<String>("GroupDescription"); }
            set { SetPropertyValue("GroupDescription", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[LoginHistory]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "LHistoryId")]
    public class LoginHistory : EntityBase
    {

        /// <summary>
        /// 登录历史ID
        /// </summary>
        public String LHistoryId
        {
            get { return GetPropertyValue<String>("LHistoryId"); }
            set { SetPropertyValue("LHistoryId", value); }
        }

        /// <summary>
        /// 用户ID
        /// </summary>
        public String UserId
        {
            get { return GetPropertyValue<String>("UserId"); }
            set { SetPropertyValue("UserId", value); }
        }

        /// <summary>
        /// 用户名
        /// </summary>
        public String UserName
        {
            get { return GetPropertyValue<String>("UserName"); }
            set { SetPropertyValue("UserName", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 角色名称
        /// </summary>
        public String RoleName
        {
            get { return GetPropertyValue<String>("RoleName"); }
            set { SetPropertyValue("RoleName", value); }
        }

        /// <summary>
        /// 客户端机器名
        /// </summary>
        public String ClientPC
        {
            get { return GetPropertyValue<String>("ClientPC"); }
            set { SetPropertyValue("ClientPC", value); }
        }

        /// <summary>
        /// 客户端IP
        /// </summary>
        public String ClientIP
        {
            get { return GetPropertyValue<String>("ClientIP"); }
            set { SetPropertyValue("ClientIP", value); }
        }

        /// <summary>
        /// 登录时间
        /// </summary>
        public DateTime? LoginTime
        {
            get { return GetPropertyValue<DateTime?>("LoginTime"); }
            set { SetPropertyValue("LoginTime", value); }
        }
    }

    [Table("[MenuButtons]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "MenuButtonId")]
    public class MenuButtons : EntityBase
    {

        /// <summary>
        /// 
        /// </summary>
        public String MenuButtonId
        {
            get { return GetPropertyValue<String>("MenuButtonId"); }
            set { SetPropertyValue("MenuButtonId", value); }
        }

        /// <summary>
        /// 功能ID
        /// </summary>
        public String FunctionId
        {
            get { return GetPropertyValue<String>("FunctionId"); }
            set { SetPropertyValue("FunctionId", value); }
        }

        /// <summary>
        /// 按钮ID
        /// </summary>
        public String ControlId
        {
            get { return GetPropertyValue<String>("ControlId"); }
            set { SetPropertyValue("ControlId", value); }
        }
    }

    [Table("[RoleAuthorizes]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "RoleAuthorizeId")]
    public class RoleAuthorizes : EntityBase
    {

        /// <summary>
        /// 角色授权ID
        /// </summary>
        public String RoleAuthorizeId
        {
            get { return GetPropertyValue<String>("RoleAuthorizeId"); }
            set { SetPropertyValue("RoleAuthorizeId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 授权ID
        /// </summary>
        public String AuthorizeCodeId
        {
            get { return GetPropertyValue<String>("AuthorizeCodeId"); }
            set { SetPropertyValue("AuthorizeCodeId", value); }
        }
    }

    [Table("[RoleColumns]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "ColumnRoleId")]
    public class RoleColumns : EntityBase
    {

        /// <summary>
        /// 角色列权限ID
        /// </summary>
        public String ColumnRoleId
        {
            get { return GetPropertyValue<String>("ColumnRoleId"); }
            set { SetPropertyValue("ColumnRoleId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 功能ID
        /// </summary>
        public String FunctionId
        {
            get { return GetPropertyValue<String>("FunctionId"); }
            set { SetPropertyValue("FunctionId", value); }
        }

        /// <summary>
        /// 权限类型
        /// </summary>
        public String RoleType
        {
            get { return GetPropertyValue<String>("RoleType"); }
            set { SetPropertyValue("RoleType", value); }
        }

        /// <summary>
        /// 字段名称
        /// </summary>
        public String FieldName
        {
            get { return GetPropertyValue<String>("FieldName"); }
            set { SetPropertyValue("FieldName", value); }
        }
    }

    [Table("[RoleMenuButtons]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "RoleMenuButtonId")]
    public class RoleMenuButtons : EntityBase
    {

        /// <summary>
        /// 角色菜单按钮ID
        /// </summary>
        public String RoleMenuButtonId
        {
            get { return GetPropertyValue<String>("RoleMenuButtonId"); }
            set { SetPropertyValue("RoleMenuButtonId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 功能ID
        /// </summary>
        public String FunctionId
        {
            get { return GetPropertyValue<String>("FunctionId"); }
            set { SetPropertyValue("FunctionId", value); }
        }

        /// <summary>
        /// 按钮ID
        /// </summary>
        public String ControlId
        {
            get { return GetPropertyValue<String>("ControlId"); }
            set { SetPropertyValue("ControlId", value); }
        }
    }

    [Table("[Roles]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "RoleId")]
    public class Roles : EntityBase
    {

        /// <summary>
        /// 角色编号
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }

        /// <summary>
        /// 
        /// </summary>
        public Int32? RoleOrder
        {
            get { return GetPropertyValue<Int32?>("RoleOrder"); }
            set { SetPropertyValue("RoleOrder", value); }
        }

        /// <summary>
        /// 角色名称
        /// </summary>
        public String RoleName
        {
            get { return GetPropertyValue<String>("RoleName"); }
            set { SetPropertyValue("RoleName", value); }
        }

        /// <summary>
        /// 角色描述
        /// </summary>
        public String RoleDescription
        {
            get { return GetPropertyValue<String>("RoleDescription"); }
            set { SetPropertyValue("RoleDescription", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[SystemLogs]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "LogId")]
    public class SystemLogs : EntityBase
    {

        /// <summary>
        /// 日志ID
        /// </summary>
        public String LogId
        {
            get { return GetPropertyValue<String>("LogId"); }
            set { SetPropertyValue("LogId", value); }
        }

        /// <summary>
        /// 日志来源
        /// </summary>
        public String LogSources
        {
            get { return GetPropertyValue<String>("LogSources"); }
            set { SetPropertyValue("LogSources", value); }
        }

        /// <summary>
        /// 日志类型ID
        /// </summary>
        public String LogCategoryId
        {
            get { return GetPropertyValue<String>("LogCategoryId"); }
            set { SetPropertyValue("LogCategoryId", value); }
        }

        /// <summary>
        /// 日志类型名称
        /// </summary>
        public String LogCategoryName
        {
            get { return GetPropertyValue<String>("LogCategoryName"); }
            set { SetPropertyValue("LogCategoryName", value); }
        }

        /// <summary>
        /// 日志内容
        /// </summary>
        public String LogContents
        {
            get { return GetPropertyValue<String>("LogContents"); }
            set { SetPropertyValue("LogContents", value); }
        }

        /// <summary>
        /// 日志备注
        /// </summary>
        public String LogRemark
        {
            get { return GetPropertyValue<String>("LogRemark"); }
            set { SetPropertyValue("LogRemark", value); }
        }

        /// <summary>
        /// 记录时间
        /// </summary>
        public DateTime? RecordTime
        {
            get { return GetPropertyValue<DateTime?>("RecordTime"); }
            set { SetPropertyValue("RecordTime", value); }
        }
    }

    [Table("[SystemParameters]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "SysParametersId")]
    public class SystemParameters : EntityBase
    {

        /// <summary>
        /// 系统参数Id
        /// </summary>
        public String SysParametersId
        {
            get { return GetPropertyValue<String>("SysParametersId"); }
            set { SetPropertyValue("SysParametersId", value); }
        }

        /// <summary>
        /// 系统参数值
        /// </summary>
        public String ParameterValue
        {
            get { return GetPropertyValue<String>("ParameterValue"); }
            set { SetPropertyValue("ParameterValue", value); }
        }

        /// <summary>
        /// 是否可编辑
        /// </summary>
        public Boolean? IsEdit
        {
            get { return GetPropertyValue<Boolean?>("IsEdit"); }
            set { SetPropertyValue("IsEdit", value); }
        }

        /// <summary>
        /// 系统参数描述
        /// </summary>
        public String ParameterDescription
        {
            get { return GetPropertyValue<String>("ParameterDescription"); }
            set { SetPropertyValue("ParameterDescription", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? ModifyOn
        {
            get { return GetPropertyValue<DateTime?>("ModifyOn"); }
            set { SetPropertyValue("ModifyOn", value); }
        }
    }

    [Table("[UserInGroups]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "GroupUserId")]
    public class UserInGroups : EntityBase
    {

        /// <summary>
        /// 机构用户ID
        /// </summary>
        public String GroupUserId
        {
            get { return GetPropertyValue<String>("GroupUserId"); }
            set { SetPropertyValue("GroupUserId", value); }
        }

        /// <summary>
        /// 机构ID
        /// </summary>
        public String GroupId
        {
            get { return GetPropertyValue<String>("GroupId"); }
            set { SetPropertyValue("GroupId", value); }
        }

        /// <summary>
        /// 用户ID
        /// </summary>
        public String UserId
        {
            get { return GetPropertyValue<String>("UserId"); }
            set { SetPropertyValue("UserId", value); }
        }
    }

    [Table("[UserInRoles]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "UserRoleId")]
    public class UserInRoles : EntityBase
    {

        /// <summary>
        /// 用户角色编号
        /// </summary>
        public String UserRoleId
        {
            get { return GetPropertyValue<String>("UserRoleId"); }
            set { SetPropertyValue("UserRoleId", value); }
        }

        /// <summary>
        /// 用户ID
        /// </summary>
        public String UserId
        {
            get { return GetPropertyValue<String>("UserId"); }
            set { SetPropertyValue("UserId", value); }
        }

        /// <summary>
        /// 角色ID
        /// </summary>
        public String RoleId
        {
            get { return GetPropertyValue<String>("RoleId"); }
            set { SetPropertyValue("RoleId", value); }
        }
    }

    [Table("[UserofSettings]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "UserSettingId")]
    public class UserofSettings : EntityBase
    {

        /// <summary>
        /// 用户设置ID
        /// </summary>
        public String UserSettingId
        {
            get { return GetPropertyValue<String>("UserSettingId"); }
            set { SetPropertyValue("UserSettingId", value); }
        }

        /// <summary>
        /// 用户ID
        /// </summary>
        public String UserId
        {
            get { return GetPropertyValue<String>("UserId"); }
            set { SetPropertyValue("UserId", value); }
        }

        /// <summary>
        /// 设置编码
        /// </summary>
        public String SettingCodeNo
        {
            get { return GetPropertyValue<String>("SettingCodeNo"); }
            set { SetPropertyValue("SettingCodeNo", value); }
        }

        /// <summary>
        /// 设置名称
        /// </summary>
        public String SettingName
        {
            get { return GetPropertyValue<String>("SettingName"); }
            set { SetPropertyValue("SettingName", value); }
        }

        /// <summary>
        /// 设置值
        /// </summary>
        public String SettingValue
        {
            get { return GetPropertyValue<String>("SettingValue"); }
            set { SetPropertyValue("SettingValue", value); }
        }

        /// <summary>
        /// 描述说明
        /// </summary>
        public String SettingDescription
        {
            get { return GetPropertyValue<String>("SettingDescription"); }
            set { SetPropertyValue("SettingDescription", value); }
        }
    }

    [Table("[Users]", DbType.SqlServer)]
    [TablesPrimaryKey(PrimaryKeyType.CustomerGUID, typeof(String), "UserId")]
    public class Users : EntityBase
    {

        /// <summary>
        /// 用户编号
        /// </summary>
        public String UserId
        {
            get { return GetPropertyValue<String>("UserId"); }
            set { SetPropertyValue("UserId", value); }
        }

        /// <summary>
        /// 用户名
        /// </summary>
        public String UserName
        {
            get { return GetPropertyValue<String>("UserName"); }
            set { SetPropertyValue("UserName", value); }
        }

        /// <summary>
        /// 密码
        /// </summary>
        public String PassWord
        {
            get { return GetPropertyValue<String>("PassWord"); }
            set { SetPropertyValue("PassWord", value); }
        }

        /// <summary>
        /// 角色编号[Id]
        /// </summary>
        public String UserRoleId
        {
            get { return GetPropertyValue<String>("UserRoleId"); }
            set { SetPropertyValue("UserRoleId", value); }
        }

        /// <summary>
        /// 机构编号[Id]
        /// </summary>
        public String GroupId
        {
            get { return GetPropertyValue<String>("GroupId"); }
            set { SetPropertyValue("GroupId", value); }
        }

        /// <summary>
        /// 用户设置ID
        /// </summary>
        public String UserSettingId
        {
            get { return GetPropertyValue<String>("UserSettingId"); }
            set { SetPropertyValue("UserSettingId", value); }
        }

        /// <summary>
        /// 是否启用
        /// </summary>
        public Boolean? IsEnable
        {
            get { return GetPropertyValue<Boolean?>("IsEnable"); }
            set { SetPropertyValue("IsEnable", value); }
        }

        /// <summary>
        /// 登录次数
        /// </summary>
        public Int32? LoginsNumber
        {
            get { return GetPropertyValue<Int32?>("LoginsNumber"); }
            set { SetPropertyValue("LoginsNumber", value); }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        public String CreateBy
        {
            get { return GetPropertyValue<String>("CreateBy"); }
            set { SetPropertyValue("CreateBy", value); }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateOn
        {
            get { return GetPropertyValue<DateTime?>("CreateOn"); }
            set { SetPropertyValue("CreateOn", value); }
        }

        /// <summary>
        /// 更改人
        /// </summary>
        public String ModifyBy
        {
            get { return GetPropertyValue<String>("ModifyBy"); }
            set { SetPropertyValue("ModifyBy", value); }
        }

        /// <summary>
        /// 更改时间
        /// </summary>
        public DateTime? 更新时间
        {
            get { return GetPropertyValue<DateTime?>("更新时间"); }
            set { SetPropertyValue("更新时间", value); }
        }
    }


}
